﻿CREATE TABLE [dbo].[codePaymentProcessor] (
    [ProcessorCode]         CHAR (1)     NOT NULL,
    [Name]                  VARCHAR (50) NOT NULL,
    [Active]                BIT          NOT NULL,
    [DefaultOnlineSystemID] INT          NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Defines the business that processes the payment transaction.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codePaymentProcessor';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Numeric processor code.', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codePaymentProcessor', @level2type = N'COLUMN', @level2name = N'ProcessorCode';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Name of the processing company', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codePaymentProcessor', @level2type = N'COLUMN', @level2name = N'Name';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Indicates whether the processor code is active (1), or not (0).', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codePaymentProcessor', @level2type = N'COLUMN', @level2name = N'Active';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The ID to identify the default online system', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'codePaymentProcessor', @level2type = N'COLUMN', @level2name = N'DefaultOnlineSystemID';

